Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SID NUMBER(38) No null 1 null NO NO NO
NAME VARCHAR2(20) No null 2 null NO NO NO
LOGIN_ID VARCHAR2(100) No null 3 null NO NO NO
ASSIGNMENT_ID VARCHAR2(100) Yes null 4 null NO NO NO
ASSIGNMENT_TAGLINE VARCHAR2(400) Yes null 5 null NO NO NO
ASSIGNMENT_OBJ_ROOT VARCHAR2(8) Yes null 6 null NO NO NO
ASSIGNMENT_OBJ_TYPE VARCHAR2(100) Yes null 7 null NO NO NO
ASSIGNMENT_OWNING_UNIT VARCHAR2(400) Yes null 8 null NO NO NO
ASSIGNMENT_ROLE VARCHAR2(100) Yes null 9 null NO NO NO
ASSIGNMENT_START_DATE DATE No null 10 null NO NO NO
ASSIGNMENT_END_DATE DATE Yes null 11 null NO NO NO
ASSIGNMENT_STATUS VARCHAR2(100) Yes null 12 null NO NO NO
CREATED_DATE DATE Yes null 13 null NO NO NO
CLOSED_ON DATE Yes null 14 null NO NO NO
CLOSED_ON_FY NUMBER Yes null 15 null NO NO NO
CREATED_ON_FY NUMBER Yes null 16 null NO NO NO
NEXT_DUE_DATE DATE Yes null 17 null NO NO NO
FINAL_DUE_DATE DATE Yes null 18 null NO NO NO
FINAL_DUE_DATE_MET VARCHAR2(3) Yes null 19 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 11-APR-23
LAST_DDL_TIME 29-FEB-24
OWNER QART
VIEW_NAME V_PERSONNEL_ASSIGNMENT_CUBE
TEXT_LENGTH 2004
TEXT SELECT DISTINCT SH.SID,                    O.SID NAME,                    U.LOGIN_ID,                    O2.ID ASSIGNMENT_ID,                    O2.TAGLINE ASSIGNMENT_TAGLINE,                    DECODE(O2T.OBJ_ROOT, 'ACT', 'Activity', 'FILE', 'File') ASSIGNMENT_OBJ_ROOT,                    O2T.DISPLAY ASSIGNMENT_OBJ_TYPE,                    OU.SH_DISPLAY ASSIGNMENT_OWNING_UNIT,                    SR.DISPLAY ASSIGNMENT_ROLE,                    SH.START_DATE ASSIGNMENT_START_DATE,                    SH.END_DATE ASSIGNMENT_END_DATE,                    S2.DISPLAY ASSIGNMENT_STATUS,                    O2.CREATED_ON CREATED_DATE,                    CASE S2.DISPLAY                       WHEN 'Closed' THEN                          S.STARTED_ON                       ELSE                          NULL                    END CLOSED_ON,                    CASE S2.DISPLAY                       WHEN 'Closed' THEN                          S.STARTED_ON_FY                       ELSE                          NULL                    END CLOSED_ON_FY,                    O2.CREATED_ON_FY CREATED_ON_FY,                    O2.NEXT_DUE_DATE NEXT_DUE_DATE,                    O2.FINAL_DUE_DATE FINAL_DUE_DATE,                    CASE                       WHEN S2.DISPLAY = 'Closed'                          AND TRUNC(S.STARTED_ON) <= TRUNC(O2.FINAL_DUE_DATE) THEN                          'Yes'                       ELSE                          'No'                    END FINAL_DUE_DATE_MET      FROM MV_ACM_STAKEHOLDER SH     INNER JOIN MV_ACM_OBJ O ON SH.STAKEHOLDER = O.SID     INNER JOIN MV_ACM_USER U ON SH.STAKEHOLDER = U.OBJ      LEFT JOIN MV_ACM_OBJ O2 ON SH.OBJ = O2.SID      LEFT JOIN MV_ACM_OBJ_TYPE O2T ON O2.OBJ_TYPE = O2T.SID      LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON SH.OBJ = OU.OBJ      LEFT JOIN MV_ACM_STATUS_HISTORY S ON SH.OBJ = S.OBJ       AND S.COMPLETED_ON IS NULL      LEFT JOIN MV_ACM_STATUS S2 ON S.STATUS = S2.SID      LEFT JOIN MV_ACM_STAKEHOLDER_ROLE SR ON SH.SH_ROLE = SR.SID
TEXT_VC SELECT DISTINCT SH.SID,                    O.SID NAME,                    U.LOGIN_ID,                    O2.ID ASSIGNMENT_ID,                    O2.TAGLINE ASSIGNMENT_TAGLINE,                    DECODE(O2T.OBJ_ROOT, 'ACT', 'Activity', 'FILE', 'File') ASSIGNMENT_OBJ_ROOT,                    O2T.DISPLAY ASSIGNMENT_OBJ_TYPE,                    OU.SH_DISPLAY ASSIGNMENT_OWNING_UNIT,                    SR.DISPLAY ASSIGNMENT_ROLE,                    SH.START_DATE ASSIGNMENT_START_DATE,                    SH.END_DATE ASSIGNMENT_END_DATE,                    S2.DISPLAY ASSIGNMENT_STATUS,                    O2.CREATED_ON CREATED_DATE,                    CASE S2.DISPLAY                       WHEN 'Closed' THEN                          S.STARTED_ON                       ELSE                          NULL                    END CLOSED_ON,                    CASE S2.DISPLAY                       WHEN 'Closed' THEN                          S.STARTED_ON_FY                       ELSE                          NULL                    END CLOSED_ON_FY,                    O2.CREATED_ON_FY CREATED_ON_FY,                    O2.NEXT_DUE_DATE NEXT_DUE_DATE,                    O2.FINAL_DUE_DATE FINAL_DUE_DATE,                    CASE                       WHEN S2.DISPLAY = 'Closed'                          AND TRUNC(S.STARTED_ON) <= TRUNC(O2.FINAL_DUE_DATE) THEN                          'Yes'                       ELSE                          'No'                    END FINAL_DUE_DATE_MET      FROM MV_ACM_STAKEHOLDER SH     INNER JOIN MV_ACM_OBJ O ON SH.STAKEHOLDER = O.SID     INNER JOIN MV_ACM_USER U ON SH.STAKEHOLDER = U.OBJ      LEFT JOIN MV_ACM_OBJ O2 ON SH.OBJ = O2.SID      LEFT JOIN MV_ACM_OBJ_TYPE O2T ON O2.OBJ_TYPE = O2T.SID      LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON SH.OBJ = OU.OBJ      LEFT JOIN MV_ACM_STATUS_HISTORY S ON SH.OBJ = S.OBJ       AND S.COMPLETED_ON IS NULL      LEFT JOIN MV_ACM_STATUS S2 ON S.STATUS = S2.SID      LEFT JOIN MV_ACM_STAKEHOLDER_ROLE SR ON SH.SH_ROLE = SR.SID
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT